************************************************************************** ** ** ** FEBRUARY 10, 1995 -> FOR IMMEDIATE RELEASE -> DBFDIRECT v2.0 ** ** ** ************************************************************************** WHAT IS IT? =========== DBFDIRECT is an easy to use yet comprehensive utility program for taking ASCII data and directly converting it to the industry standard DBF file format and vice versa. DBFDIRECT was designed for people who convert data from ASCII to DBF or DBF to ASCII on a regular, routine basis, such as accepting order history data from an AS400 and converting it to a DBF file that is used by some PC application. Or, using a PC application as the source of input an then exporting that data to another system or application. If you routinely transfer ASCII data to from a fixed or comma delimited format to DBF files or vice-versa then DBFDIRECT is for you! WHY IS IT DIFFERENT? ==================== Unlike other conversion programs that require you to save the entire data file you are converting in some temporary file format that is only used by the conversion program, DBFDIRECT takes standard ASCII data and converts it DIRECTLY to a DBF file. There is no hidden middle step, wasted hard disk space, or extra runtime incurred. Plus, DBFDIRECT has many features which make it unique like: - 4 different modes - IMPORT/EXPORT/EXTRACT/OPERATION. - Supports all data types (Character, Numeric, Date, Memo, Logical). - Create Unique key values for any field (ie, KEY01,KEY02,KEY03). - Update option to check for existence of key value before importing or updatin data. - Updating only certain fields of a record (ie. inventory, status) based on key value. - Partial updating of a field (Insert,Replace,Replace&Insert, Replace&Delete,Replace&Delete all) based on key value. - Powerful 'skip data' intellegence to by-pass certain data during all modes of operation (ie, skip records with part number of 432348). - On-the-fly math functions to add,subtract,multiply,etc fields and place results in any field desired, even when input file is ASCII. - Roll-Up option to perform lookup in child table based on key value and return result to a field in parent (ie, add up extended price of line items in the item dbf and place result in total field in order dbf). - Relationship Link Command to relate up to 5 DBF input files & produce a single, flat-file ASCII output file. - Import data into 10 different DBF files on a single pass. - Supports NTX and CDX files, optionally creating any required index. - Simple OPERATION mode to scan a DBF file and perform any type of replace, update, modify, etc. (ie update a code based on some combination of field values). - Option to create or zap a DBF before placing data in it. - Plus much more ... HOW DOES IT WORK? ================= DBFDIRECT is a powerful conversion program that uses a "SCRIPT" file to instruct it what operations to perform and on what data. Using DBFDIRECT is simple: DBFDIRECT